Copyright: (c) Copyright 1996. Intranet 2001, Inc.


 Intranet Database Assistant Help Index

Basic Syntax

Forms and Variables

Configuration

About IDBA

For More Information

About Intranet 2001,Inc.


 Basic Syntax

<!QUERY::DSN=SourceName::SQL = SQL statement::HTM = Output Format::END>

Display Records - Select SQL statements

Output Format currently supported are:

•	TABLE

•	ULIST

•	OLIST

•	MENU

More Output formats will be supported in the future.

<!QUERY:: DSN=NorthWind::SQL=Select * From Customers::HTM=TABLE::END>

<!QUERY:: DSN=NorthWind::SQL=Select * From Customers::HTM=ULIST::END>

Update/Insert/Delete or Action Queries

Output Format is MODIFY

<!QUERY:: DSN=NorthWind::SQL=Insert  into Employees EmployeeID, lastname, firstname values (25,’John’,’Doe’)::HTM=MODIFY::END>

The above query is not  very useful without variables.

Stored Procedures

Output Format is MODIFY

<!QUERY:: DSN=NorthWind::SQL=execute AddEmployee (25,’John’,’Doe’) ::HTM=MODIFY ::END>

The above query is not  very useful without variables.

Other Specifiers

•	OK=XXX:: Outputs the user specified message "XXX" in HTML on success of a database query.

•	FAIL=XXX:: Outputs the user specified message "XXX" in HTML format on failure of a database query.

NorthWind is a MS Access sample database.


Forms and Variables

The action URL specifies the page which contains the query to be executed. The Parameters are passed to the variables in the query string.

Variable are of the type:

VAR(VARIABLE_ID, VARIABLE_TYPE)

where VARIABLE_TYPE can be one of:

•	STR

•	NUM

•	DATE

and VARIABLE_ID is the name of the control on the form page.

Examples

Result Query HTML Page

<!QUERY::DSN=NorthWind::SQL=SELECT * From [Sales by Category]

WHERE CategoryName = VAR(CategoryNameX,STR)::HTM=TABLE::END>

Form HTML Page

<form METHOD=GET action = "SalesCategoryResult.htm" >

<p><select name="CategoryNameX" size=1>

<option selected>Beverages</option>

<option>Condiments</option>

<option>Confections</option>

<option>Dairy Products</option>

<option>Grains/Cereals</option>

<option>Meat/Poultry</option>

<option>Produce</option>

<option>Seafood</option>

</select></p>

<p><input type=submit> <input type=reset></p>

</form>


Configuration

Listen on HTTP Port : Specifies the TCP/IP port to listen on. Default is 80. Must be a positive number.

Maximum Clients allowed : Specifies the maximum clients that are allowed to be serviced. Default value is 10.

HTML Files

Base Path : This is the path where the HTML files are located.

Default HTML File : Default file to be sent to browser when no explicit file is specified.

If the Server is running on Alpha1, a PC on the network and a request like http://Alpha1/ comes.

This gets translated to transfer the QueryN.htm file from the C:\IDBA directory and the browser displays this file. If the request is http://Alpha1/support.htm then the file support.htm is transferred to the browser.

Tag : Specifies the Tag file to be sent.

Log File : Logs messages that the server window displays to a file

Status Messages : Enables output for logging.

DataSources : This tab lets you add datasources that IDBA supports. The left box shows all the avaliable ODBC datasources and lets you add or remove any datasource that IDBA uses. This allows you to select the databases that can be browsed into.


About Intranet Database Assistant

The Intranet Database Assistant, is a low cost/high performance Web Database product, which works with multiple ODBC datasources.

It provides a Quick and Easy way to access your databases via HTML.

•	Create dynamic web pages that display data directly from your databases !

•	No CGI programming ! No Perl Scripting ! No Additional Web Server Required !

•	Co-exists with any other Web Server.

•	Just Plain SQL queries, and very simple IDBA-HTML syntax.

•	Multiple Queries can be generated dynamically within the same page !

•	Generates powerful HTML objects like TABLES and LISTS, direct from your database.

•	Build forms to accept and store data directly to your database (dynamic updates).

•	Customize your own responses to SQL errors.

•	Build any low cost - high performance Intranet application.


For More Information

Please contact us for more information at

Intranet 2001, Inc.

9220 S.W. Barbur Blvd #119-282

Portland, OR 97291

WWW: http://www.inet2001.com

Email : 	info@inet2001.com

sales@inet2001.com

Tel:	(503) 968 7278

Fax: 	(503) 590 2405

For technical support

Email : 	support@inet2001.com


About Intranet 2001, Inc.

Intranet 2001, Inc. has been founded to help corporations build up intranet solutions which tie seamlessly with their internet efforts. The goal is to help companies migrate from the current legacy systems to the Client/Server/Intranet based efforts.

•	Develop state of the art modular products.

•	Work with partners to implements solutions based on our products.

•	Co-Develop legacy data access modules which tie in our products. This enables corporations to build intranet solutions that interact with their host systems.